2016-07-22 - 27629 - Rel Notes - Datasource report for roc and b2b orders #2016BIReleaseNotes
Release Notes:
27629 - Datasource report for ROC and B2B orders
Admin Info
Purpose
|
Need to create data source report for ROC and B2B orders.
|
Release No
|
001
|
Submitted
|
07/22/2016
|
Submitted by
|
Dhananjay G
|
Source/Destination Systems
|
BOBJ 4.1 Dev to BOBJ 4.1 Prod
|
Release Sent To
|
Bibin Mohan
|
Object(s) Created By
|
Dhananjay G
|
Object(s) Tested By
|
Dhananjay G
|
Report Name
ROC011 - ROCB2B orders report.
Name of the ECC tables
VBAK
VBAP
VBEP
VBKD
VBUK
KNA1
MARA
LIKP
LIPS
MAKT
TVZBT
TVV2T
T151T
ADR6
Summary Level Check
Test Conducted by using Sales Document 0003247618:
SNo
|
Test Case
|
Report
|
ECC
|
Result
|
1
|
Sales_Organization
|
1000
|
1000
|
Pass
|
2
|
Cust_ID
|
1005660
|
1005660
|
Pass
|
3
|
Cust_Desc
|
TAYLORS SPORTS BESTMORS
|
TAYLORS SPORTS BESTMORS
|
Pass
|
4
|
ROC Order number
|
3018268
|
3018268
|
Pass
|
5
|
order number
|
3247618
|
3247618
|
Pass
|
6
|
material number
|
11289008
|
11289008
|
Pass
|
7
|
material description
|
NFL16 SPORT KNIT TAMBUCCC OTC
|
NFL16 SPORT KNIT TAMBUCCC OTC
|
Pass
|
8
|
GRID_ID
|
OSFA
|
OSFA
|
Pass
|
9
|
Size
|
OSFA
|
OSFA
|
Pass
|
10
|
Season
|
RES
|
RES
|
Pass
|
11
|
Collection
|
F763
|
F763
|
Pass
|
12
|
PONumber
|
NE725
|
NE725
|
Pass
|
13
|
ship to
|
1005660
|
1005660
|
Pass
|
14
|
ship to desc
|
TAYLORS SPORTS BESTMORS
|
TAYLORS SPORTS BESTMORS
|
Pass
|
15
|
Sales_Person
|
TC
|
TC
|
Pass
|
16
|
creation date
|
07/25/2016
|
07/25/2016
|
Pass
|
17
|
delivery date
|
08/01/2016
|
08/01/2016
|
Pass
|
18
|
CancelDate
|
08/31/2016
|
08/31/2016
|
Pass
|
19
|
ShipDate
|
|
|
Pass
|
20
|
Distribution_Channel
|
10
|
10
|
Pass
|
21
|
Division
|
0
|
0
|
Pass
|
22
|
Terms_Code
|
Z001
|
Z001
|
Pass
|
23
|
Terms_Desc
|
30 days Net
|
30 days Net
|
Pass
|
24
|
CarrierService] usps / fed ex
|
11
|
11
|
Pass
|
25
|
Carrier_Desc
|
BESTWAY GND
|
BESTWAY GND
|
Pass
|
26
|
CustGroupID
|
0
|
0
|
Pass
|
27
|
CustGroup_Desc
|
Dealer Disc 0%
|
Dealer Disc 0%
|
Pass
|
28
|
ContactPhone
|
|
|
Pass
|
29
|
ContactFax
|
|
|
Pass
|
30
|
ContactEmail
|
bestemors@aol.com
|
bestemors@aol.com
|
Pass
|
31
|
Quantity
|
6
|
6
|
Pass
|
32
|
UOM
|
EA
|
EA
|
Pass
|
Reference Document(Specification)
2016-07-12 - 27629 - Spec - Datasource report for roc and b2b orders
Sno.
|
Test Case
|
Report
|
ECC
|
Result
|
1
|
Sales_Organization
|
1000
|
1000
|
Pass
|
2
|
Cust_ID
|
1005660
|
1005660
|
Pass
|
3
|
Cust_Desc
|
TAYLORS SPORTS BESTMORS
|
TAYLORS SPORTS BESTMORS
|
Pass
|
4
|
ROC Order number
|
3018268
|
3018268
|
Pass
|
5
|
order number
|
3247618
|
3247618
|
Pass
|
6
|
material number
|
11289008
|
11289008
|
Pass
|
7
|
material description
|
NFL16 SPORT KNIT TAMBUCCC OTC
|
NFL16 SPORT KNIT TAMBUCCC OTC
|
Pass
|
8
|
GRID_ID
|
OSFA
|
OSFA
|
Pass
|
9
|
Size
|
OSFA
|
OSFA
|
Pass
|
10
|
Season
|
RES
|
RES
|
Pass
|
11
|
Collection
|
F763
|
F763
|
Pass
|
12
|
PONumber
|
NE725
|
NE725
|
Pass
|
13
|
ship to
|
1005660
|
1005660
|
Pass
|
14
|
ship to desc
|
TAYLORS SPORTS BESTMORS
|
TAYLORS SPORTS BESTMORS
|
Pass
|
15
|
Sales_Person
|
TC
|
TC
|
Pass
|
16
|
creation date
|
07/25/2016
|
07/25/2016
|
Pass
|
17
|
delivery date
|
08/01/2016
|
08/01/2016
|
Pass
|
18
|
CancelDate
|
08/31/2016
|
08/31/2016
|
Pass
|
19
|
ShipDate
|
|
|
Pass
|
20
|
Distribution_Channel
|
10
|
10
|
Pass
|
21
|
Division
|
0
|
0
|
Pass
|
22
|
Terms_Code
|
Z001
|
Z001
|
Pass
|
23
|
Terms_Desc
|
30 days Net
|
30 days Net
|
Pass
|
24
|
CarrierService] usps / fed ex
|
11
|
11
|
Pass
|
25
|
Carrier_Desc
|
BESTWAY GND
|
BESTWAY GND
|
Pass
|
26
|
CustGroupID
|
0
|
0
|
Pass
|
27
|
CustGroup_Desc
|
Dealer Disc 0%
|
Dealer Disc 0%
|
Pass
|
28
|
ContactPhone
|
|
|
Pass
|
29
|
ContactFax
|
|
|
Pass
|
30
|
ContactEmail
|
bestemors@aol.com
|
bestemors@aol.com
|
Pass
|
31
|
Quantity
|
6
|
6
|
Pass
|
32
|
UOM
|
EA
|
EA
|
Pass
|